﻿/*Все строки прайсов*/
CREATE VIEW [dbo].[vwAllPricesRows]
AS
SELECT     plp.Id, plp.ContragentId, gvc.GoodsCode, gvc.GoodsName, g.CountryName, g.ManufacturerName, plp.Price, c.ShortName, gvc.GoodsId, g.FullName, CAST(1 AS BIT) 
                      AS Parsed
FROM         PR.PriceLinesParsed AS plp INNER JOIN
                      CA.Contragents AS c ON plp.ContragentId = c.Id AND c.Id <> 319895 INNER JOIN
                      CA.GoodsVsContragents AS gvc ON plp.GoodsVsContragentsId = gvc.Id INNER JOIN
                      dbo.vwGoodsDetailed AS g ON gvc.GoodsId = g.Id
UNION ALL
SELECT     plnp.Id, plnp.ContragentId, plnp.GoodsCode, plnp.GoodsName, plnp.CountryName, plnp.ManufacturerName, plnp.Price, c.ShortName, CAST(NULL AS int) AS GoodsId, 
                      CAST(NULL AS VARCHAR(100)) AS FullName, CAST(0 AS BIT) AS Parsed
FROM         PR.PriceLinesNOTParsed AS plnp INNER JOIN
                      CA.Contragents AS c ON plnp.ContragentId = c.Id
WHERE     (plnp.ContragentId <> 193118) AND (plnp.ContragentId <> 319895) and (plnp.ContragentId <>514142) and (plnp.ContragentId <>319895)

GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPane1', @value = N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4[30] 2[40] 3) )"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 3
   End
   Begin DiagramPane = 
      PaneHidden = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 5
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'vwAllPricesRows';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPaneCount', @value = 1, @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'vwAllPricesRows';

